Program and Project Management professional with 20+ years experience in a variety of industries, including Banking & Finance, Management Consulting, Telecommunications, Data Science and Retail.
I've only been using Samrtsheet for 9 months now, but I have 15 years experience as an Excel SME including custom solutions using VBA and external Data.
Hi, Your core issue here is the "1". Numeric values do not need quotes. You should also include a FALSE value in case the condition is not TRUE. So simply change your formula to: =IF(OR([Ri…